Round 1: Technical Discussion

📍 Project-Related Questions: Questions regarding your project experience, tools used, basic architecture.

📍 Data Warehousing Concepts: Questions on ETL processes, fact and dimension tables, normalisation, and Slowly Changing Dimensions (SCD).

📍 Python Questions (Easy Difficulty): Math concepts, String manipulation

📍 SQL question on pattern matching and

📍Difference between repartition ,coalesce

📍Difference between union ,union all.

📍Spark optimisations

📍Types of joins in spark-left anti vs semi join

Round 2: Technical Discussion

📍 Project-Related Questions: Detailed questions regarding your project experience, focusing on the architecture, tools used, challenges faced, and how you approached various tasks.

📍Roles and responsibilities in current project and leadership avenues if any

📍Implement unity catalog in production

📍Questions on basic python, functions(lambda)

📍Difference between map, flatmap.

📍How handled client escalation and team members

Round 3: Human Resource Manager Discussion

📍Why Fractal-future aspirations?

📍If you have better offer letter then why still you want to join here

📍What arena are you looking for in future?